<?php

/**
 * This is the model class for table "{{category_lang}}".
 *
 * The followings are the available columns in table '{{category_lang}}':
 * @property integer $id
 * @property integer $categoryID
 * @property string $name
 * @property string $description
 * @property string $languageID
 */
class CategoryLang extends CActiveRecord
{
  /**
   * Returns the static model of the specified AR class.
   * @param string $className active record class name.
   * @return CategoryLang the static model class
   */
  public static function model($className=__CLASS__)
  {
    return parent::model($className);
  }

  /**
   * @return string the associated database table name
   */
  public function tableName()
  {
    return '{{category_lang}}';
  }

  /**
   * @return array validation rules for model attributes.
   */
  public function rules()
  {
    // NOTE: you should only define rules for those attributes that
    // will receive user inputs.
    return array(
    array('categoryID, name, languageID', 'required'),
    array('categoryID', 'numerical', 'integerOnly'=>true),
    array('name', 'length', 'max'=>200),
    array('languageID', 'length', 'max'=>2),
    // The following rule is used by search().
    // Please remove those attributes that should not be searched.
    array('id, categoryID, name, description, languageID', 'safe', 'on'=>'search'),
    );
  }

  /**
   * @return array relational rules.
   */
  public function relations()
  {
    // NOTE: you may need to adjust the relation name and the related
    // class name for the relations automatically generated below.
    return array(
		  'category' => array(self::BELONGS_TO, 'Category', 'categoryID'),
    );
  }

  /**
   * @return array customized attribute labels (name=>label)
   */
  public function attributeLabels()
  {
    return array(
			'id' => 'ID',
			'categoryID' => 'Category',
			'name' => 'Name',
			'description' => 'Description',
			'languageID' => 'Language',
    );
  }

 	public function getName($categoryID) {
 	  $model = CategoryLang::model()->findByAttributes(array('categoryID' => $categoryID, 'languageID' => Yii::app()->session['language']));
 	  if (!empty($model)) {
 	    return $model->name;
 	  } else {
 	    return 'N/A';
 	  }
 	}

 	/**
 	 * Retrieves a list of models based on the current search/filter conditions.
 	 * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
 	 */
 	public function search()
 	{
 	  // Warning: Please modify the following code to remove attributes that
 	  // should not be searched.

 	  $criteria=new CDbCriteria;

 	  $criteria->compare('id',$this->id);
 	  $criteria->compare('categoryID',$this->categoryID);
 	  $criteria->compare('name',$this->name,true);
 	  $criteria->compare('description',$this->description,true);
 	  $criteria->compare('languageID',$this->languageID,true);

 	  return new CActiveDataProvider($this, array(
			'criteria'=>$criteria,
 	  ));
 	}
}